package c.x.jy.dao.dao;

import c.x.jy.dao.dto.MemberRechargeRecordEntityDto;
import c.x.jy.dao.entity.MemberRechargeRecordEntity;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.core.toolkit.Constants;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

/**
 * 会员充值账户流水
 * 
 * @author amwhyh
 * @email xxx@xx.com
 * @date 2021-05-30 15:19:46
 */
@Mapper
public interface MemberRechargeRecordDao extends BaseMapper<MemberRechargeRecordEntity> {

    @Select("select mrr.*,m.nickname as userName from t_member_recharge_record mrr LEFT JOIN t_member m on mrr.member_id=m.id  ${ew.customSqlSegment}")
    IPage<MemberRechargeRecordEntityDto> listforweb(IPage<MemberRechargeRecordEntity> page, @Param(Constants.WRAPPER)  QueryWrapper<MemberRechargeRecordEntity> query);
}

